from sqlalchemy import Column, ForeignKey, Date
from sqlalchemy.orm import relationship
from sqlalchemy.dialects.oracle import VARCHAR2, NUMBER
from app.db.base import Base


# Dietary Preferences Lookup
class DietaryPreferences(Base):
    __tablename__ = 'DIETARY_PREFERENCES'
    __table_args__ = {'schema': 'IARO_CAREER'}

    dietary_pref_id = Column(NUMBER, primary_key=True)
    dietary_pref_desc = Column(VARCHAR2(500), nullable=False)

    # One dietary preference -> many scholars
    scholars = relationship("Scholar", back_populates="dietary_preference")
